package loginbean;

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.sql.*;
import java.sql.*;

public class login extends HttpServlet {

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        System.out.println("MySQL Connect Example.");
        Connection conn = null;

        String username = "";
        String userpass = "";
        String strQuery = "";
        Statement st = null;
        ResultSet rs = null;
        HttpSession session = request.getSession(true);
        try {

            System.out.println("before classforname");
            conn = new DBManager().getDatabaseConnection();
            System.out.println("after classforname connection");
            if (request.getParameter("username") != null
                    && request.getParameter("username") != "" && request.getParameter("password") != null
                    && request.getParameter("password") != "") {
                username = request.getParameter("username").toString();
                userpass = request.getParameter("password").toString();
                strQuery = "select * from mydb.TenantTable where"
                        + " TenantName='" + username + "' and  TenantPassword='" + userpass + "'";
                System.out.println(strQuery);
                st = conn.createStatement();
                rs = st.executeQuery(strQuery);
                int count = 0;
                while (rs.next()) {
                    session.setAttribute("username", rs.getString(2));
                    session.setAttribute("tenantid", rs.getString(1));
                    count++;
                }
                if (count > 0) {
                    response.sendRedirect("welcome.jsp");
                } else {
                    response.sendRedirect("login.jsp");
                }
            }
            System.out.println("Connected to the database");
            conn.close();
            System.out.println("Disconnected from database");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}